Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_FACT_LEVEL_USES

`ALL_OLAP2_FACT_LEVEL_USES` shows the joins between dimension tables and fact tables in a star or snowflake schema. For more information, see "Joining Fact Tables with Dimension Tables".

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the cube.
`CUBE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the cube.
`DIMENSION_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension.
`DIMENSION_NAME` | `NUMBER` | `NOT NULL` | Name of the dimension.
`DIMENSION_ALIAS` | `VARCHAR2(30)` |  | Dimension alias (if applicable).
`HIERARCHY_NAME` |  | `NOT NULL` | Name of the hierarchy.
`DIM_HIER_COMBO_ID` | `NUMBER` | `NOT NULL` | ID of the dimension hierarchy combination associated with this fact table.
`LEVEL_NAME` | `VARCHAR2(30)` |  | Name of the level within the hierarchy where the mapping occurs.
`FACT_TABLE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the fact table.
`FACT_TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the fact table.
`COLUMN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the foreign key column in the fact table.
`POSITION` | `NUMBER` |  | Position of this column within a multi-column key.
`DIMENSION_KEYMAP_TYPE` | `VARCHAR2(30)` | `NOT NULL` | Type of key mapping for the fact table. Values may be: `LL` (Lowest Level), when only lowest-level dimension members are stored in the key column. The fact table is unsolved. `ET` (Embedded Totals), when dimension members for all level combinations are stored in the key column. The fact table is solved (contains embedded totals for all level combinations).
`FOREIGN_KEY_NAME` | `VARCHAR2(30)` |  | Name of the foreign key constraint applied to the foreign key column. Constraints are not used by the `CWM2` APIs.